SELECT 
p.product_id products_id, 
p.quantity products_quantity, 
p.model products_model, 
p.image products_image, 
p.price products_price, 
p.date_added products_date_added, 
p.date_modified products_last_modified, 
p.date_available products_date_available, 
p.weight products_weight, 
p.status products_status, 
p.tax_class_id products_tax_class_id, 
p.manufacturer_id manufacturers_id, 
pd.name products_name

FROM 
<@PREFIX>product p left join 
<@PREFIX>product_to_store pts on (p.product_id = pts.product_id) left join 
<@PREFIX>product_description pd on (p.product_id = pd.product_id)
 
where
pts.store_id = <@PROCESS@>@select trim(substring ( imp_extid from 7 for 200)) from 
 IMP_LINK b join imp_source_extra a on a.imp_sourceid = b.imp_sourceid and 
a.wshopid = b.Wgroupid  and a.imp_sourceid = <@SOURCEID@> ##
pd.language_id = %s and (
(p.date_added >=  %s) and 
(p.date_modified is null or p.date_modified =  00000000 ) or p.date_modified >= %s ) and (
(p.date_added <=  %s) and (p.date_modified is null or p.date_modified =  00000000 ) or p.date_modified <= %s ) 
order by p.product_id

